Google Sheets
Description
Google Spreadsheets Plugin has been designed to perform tasks on spreadsheets on Google Drive.
Prerequisites:
- Google developer console account should be created and subscribed: https://console.developers.google.com/.
- APIs for Google Drive and Google Spreadsheet should be enabled.
- Client ID and Client Secret should be generated from the Credentials tab. In exchange for the Client ID and Client Secret, a Refresh Token can be generated.
tip
Google Spreadsheets plugin steps read from Google Drive. Google Drive differentiates between Excel files and Google Spreadsheet files. However, Google Spreadsheets plugin steps support only Google Spreadsheet files.
References:
- Google Spreadsheet documentation- https://developers.google.com/sheets/api
Refer Google Sheets Refresh Token Generation for enabling APIs, creating Client ID and Client Secret and generating Refresh Token.
Common Action Buttons:
| No. | Field Name | Description |
|---|---|---|
| 1 | OK | On click of this button. It will check the field values. If any required field values are missing, then it will display validation error message. If all the required field values are provided then it will save the field values. |
| 2 | Cancel | On click of this button, it will cancel the window and do not save any values |